{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CP09","Fornecedores","RefParts II","RefParts","Fornecedores II","Input"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CP09","index":0,"n_rows":3,"n_cols":32,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,14,0,31],[0,6,0,13],[0,1,0,5]]}
[null,"Códigos dos artigos por empresa",null,null,null,null,"Condições a carregar no arcodo",null,null,null,null,null,null,null,"Outras ordens a criar nos artigos além da do acordo"]
["Descrição","BT","RL","EVA","RA","TEJO","FORNECEDOR","NIF","ordem","Marca","Referência","P Un","Data inicio","Data de fim","FORNECEDOR","NIF","ordem","Marca","Referência","P Un","FORNECEDOR","NIF","ordem","Marca","Referência","P Un","FORNECEDOR","NIF","ordem","Marca","Referência","P Un"]
["GÁS SUVA 134A","003490117","003490133","003490000","003490034","003490109","JBF",514308761,"01","N/D","R134A",32.75,"2024-08-01","2999-12-31","KRAULTI",502271450,"01","N/D","R134A",32.83,"ARL",501165738,"01","N/D","R134A",34.6]

{"sheet":"Fornecedores","index":1,"n_rows":4,"n_cols":29,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11]]}
["Nome","NIF","BT",null,"RL",null,"Gupo Algarve",null,"Gupo Alentejo",null,"Grupo Tejo"]
["JBF",514308761,22511,49337,22511,49337,22511,49337,2254,99999,22511,49337,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"745","v":745},{"$f":"AA2","v":745},{"$f":"AB2*8","v":5960}]
["KRAULTI",502271450,22511,20213,22511,"08024",22511,"0017",2254,"03627",22511,21655]
["ARL",null,22511,99999,22511,99999,22511,99999,2254,99999,22511,99999]

{"sheet":"RefParts II","index":2,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Ref Acordo","Nome Acordo","Empresa","Descrição Peça","CAE","Fornecedor","CFE","Marca Modelo","VUnit","Acordo","Data I","Data F"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","BT","GÁS SUVA 134A","003490117.10","JBF","49337.10","N/D: R134A",32.75,"Acordo","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","BT","GÁS SUVA 134A","003490117.10","KRAULTI","20213.10","N/D: R134A",32.83,"Alternativa 1","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","BT","GÁS SUVA 134A","003490117.10","ARL","99999.10","N/D: R134A",34.6,"Alternativa 2","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RL","GÁS SUVA 134A","003490133.16","JBF","49337.16","N/D: R134A",32.75,"Acordo","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RL","GÁS SUVA 134A","003490133.16","KRAULTI","08024.16","N/D: R134A",32.83,"Alternativa 1","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RL","GÁS SUVA 134A","003490133.16","ARL","99999.16","N/D: R134A",34.6,"Alternativa 2","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","EVA","GÁS SUVA 134A","003490000.9","JBF","49337.9","N/D: R134A",32.75,"Acordo","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","EVA","GÁS SUVA 134A","003490000.9","KRAULTI","08024.9","N/D: R134A",32.83,"Alternativa 1","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","EVA","GÁS SUVA 134A","003490000.9","ARL","99999.9","N/D: R134A",34.6,"Alternativa 2","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RA","GÁS SUVA 134A","003490034.8","JBF","49337.8","N/D: R134A",32.75,"Acordo","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RA","GÁS SUVA 134A","003490034.8","KRAULTI","08024.8","N/D: R134A",32.83,"Alternativa 1","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RA","GÁS SUVA 134A","003490034.8","ARL","99999.8","N/D: R134A",34.6,"Alternativa 2","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RT","GÁS SUVA 134A","003490109.4","JBF","49337.4","N/D: R134A",32.75,"Acordo","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RT","GÁS SUVA 134A","003490109.4","KRAULTI","08024.4","N/D: R134A",32.83,"Alternativa 1","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RT","GÁS SUVA 134A","003490109.4","ARL","99999.4","N/D: R134A",34.6,"Alternativa 2","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","ROeste","GÁS SUVA 134A","003490109.84","JBF","49337.84","N/D: R134A",32.75,"Acordo","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","ROeste","GÁS SUVA 134A","003490109.84","KRAULTI","08024.84","N/D: R134A",32.83,"Alternativa 1","2024-08-01","2999-12-31"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","ROeste","GÁS SUVA 134A","003490109.84","ARL","99999.84","N/D: R134A",34.6,"Alternativa 2","2024-08-01","2999-12-31"]

{"sheet":"RefParts","index":3,"n_rows":7,"n_cols":19,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Ref Acordo","Nome Acordo","Empresa","Descrição Peça","CAE","Acodro: Fornecedor","Acordo: CFE","Acordo: Marca Modelo","Acordo: VUnit","Acordo: Data I","Acordo: Data F","Alt1: Fornecedor","Alt1: CFE","Alt1: Marca Modelo","Alt1: VUnit","Alt2: Fornecedor","Alt2: CFE","Alt2: Marca Modelo","Alt2: VUnit"]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","BT","GÁS SUVA 134A","003490117.10","JBF","49337.10","N/D: R134A",32.75,"2024-08-01","2999-12-31","KRAULTI","20213.10","N/D: R134A",32.83,"ARL","99999.10","N/D: R134A",34.6]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RL","GÁS SUVA 134A","003490133.16","JBF","49337.16","N/D: R134A",32.75,"2024-08-01","2999-12-31","KRAULTI","08024.16","N/D: R134A",32.83,"ARL","99999.16","N/D: R134A",34.6]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","EVA","GÁS SUVA 134A","003490000.9","JBF","49337.9","N/D: R134A",32.75,"2024-08-01","2999-12-31","KRAULTI","08024.9","N/D: R134A",32.83,"ARL","99999.9","N/D: R134A",34.6]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RA","GÁS SUVA 134A","003490034.8","JBF","49337.8","N/D: R134A",32.75,"2024-08-01","2999-12-31","KRAULTI","08024.8","N/D: R134A",32.83,"ARL","99999.8","N/D: R134A",34.6]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","RT","GÁS SUVA 134A","003490109.4","JBF","49337.4","N/D: R134A",32.75,"2024-08-01","2999-12-31","KRAULTI","08024.4","N/D: R134A",32.83,"ARL","99999.4","N/D: R134A",34.6]
["CP09.2024.00001","CP09.2024: Gás Refrigerante","ROeste","GÁS SUVA 134A","003490109.84","JBF","49337.84","N/D: R134A",32.75,"2024-08-01","2999-12-31","KRAULTI","08024.84","N/D: R134A",32.83,"ARL","99999.84","N/D: R134A",34.6]

{"sheet":"Fornecedores II","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Empresa","Nome","CFE"]
["BT","JBF","49337.10"]
["BT","KRAULTI","20213.10"]
["BT","ARL","99999.10"]
["RL","JBF","49337.16"]
["RL","KRAULTI","08024.16"]
["RL","ARL","99999.16"]
["EVA","JBF","49337.9"]
["EVA","KRAULTI","08024.9"]
["EVA","ARL","99999.9"]
["RA","JBF","49337.8"]
["RA","KRAULTI","08024.8"]
["RA","ARL","99999.8"]
["RT","JBF","49337.4"]
["RT","KRAULTI","08024.4"]
["RT","ARL","99999.4"]
["ROeste","JBF","49337.84"]
["ROeste","KRAULTI","08024.84"]
["ROeste","ARL","99999.84"]

{"sheet":"Input","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nome Concurso","CP09.2024","Gás Refrigerante"]
[null,"Base Cod. Fornecedores","BT","RL","Universo Algarve","Universo Alentejo","Universo Tejo","Universo Tejo"]
[null,"Empresas","BT","RL","EVA","RA","RT","ROeste"]
[null,"Cod. Empresas",10,16,9,8,4,84]
[null,"Nº Empresas AS400",5,"começa na col","B",{"$f":"COLUMN(INDIRECT(E6&\"1\"))","v":2}]
[null,"Ref. Peças AS400","BT","RL","EVA","RA","TEJO","TEJO"]
[null,"Dimensão Propostas",6,"colunas"]